A New Technique for Database Fragmentation in Distributed Systems
نویسندگان
چکیده
Improving the performance of a database system is one of the key research issues now a day. Distributed processing is an effective way to improve reliability and performance of a database system. Distribution of data is a collection of fragmentation, allocation and replication processes. Previous research works provided fragmentation solution based on empirical data about the type and frequency of the queries submitted to a centralized system. These solutions are not suitable at the initial stage of a database design for a distributed system. In this paper we have presented a fragmentation technique that can be applied at the initial stage as well as in later stages of a distributed database system for partitioning the relations. Allocation of fragments is done simultaneously in our algorithm. Result shows that proposed technique can solve initial fragmentation problem of relational databases for distributed systems properly.
منابع مشابه
A Distributed Object Based Design Technique
Distributed relational databases beneet greatly from fragmentation and allocation and these beneets should be realized in a distributed object environment. Fragmentation enhances application performance by reducing the amount of irrelevant data accessed and the amount of data transferred unnecessarily between distributed sites. This paper presents a review of early work on distributed database ...
متن کاملHorizontal Fragmentation Technique in Distributed Database
Distributed database technology is expected to have a significant impact on data processing in the upcoming years. Today’s business environment has an increasing need for distributed database and Client/server applications as the desire for consistent, scalable, reliable and accessible information is steadily growing. Distributed processing is an effective way to improve reliability and perform...
متن کاملOptimal Class Fragmentation Ordering in Object Oriented Databases
Distributed Object Oriented Databases require class fragmentation, performed either horizontally or vertically. Complex class relationships like aggregation and/or association are often represented as two-way references or object-links between classes. In order to obtain a good quality horizontal fragmentation, an optimal class processing order is needed. We present in this paper a new techniqu...
متن کاملA New Data Re-Allocation Model for Distributed Database Systems
An efficient functionality of any distributed database system “DDBS” is highly dependent on its proper design in terms of the adopted fragmentation and allocation methods. However, an optimal fragmentation and allocation design techniques could be very complex and requires good experiences and knowledge to reach. Fragmentation of a large, global databases are performed by dividing the database ...
متن کاملSecurity and Concurrency Control in Distributed Database System
This paper reviews the security issues and concurrency control in distributed database system. In this paper we have concerned about the features of distributed database system and its security issues. Distributed database is a collection of databases that can be stored at different computer network sites. This paper provides various aspects like fragmentation, types of fragmentation, replicati...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2010